UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XywSsZdaAJ3V7FOQMe9pkExbjkeKPlgw5JHxTcftE8='
WHERE
key_id = 'e3acaf64f38d578e1334ca19d70143c742ab4d90448a6a7951edfd919c3f9f7e'
AND (
token = '/XywSsZdaAJ3V7FOQMe9pkExbjkeKPlgw5JHxTcftE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)