UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '41jLXTXwgh93QjoP6WQ9l3t4IJrRe6aBIJ60SLu7QTI='
WHERE
key_id = '847715ce6ccb9bec776aecfede7b8e0604f2e5fd090c5007aeae3b71dd6219d5'
AND (
token = '41jLXTXwgh93QjoP6WQ9l3t4IJrRe6aBIJ60SLu7QTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)