UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YJd/wq5ZiKwreCthfvuxGlpoP/o5gausrrZKSR9C/Zw='
WHERE
key_id = '77a19927d43120792137e4338ea5ee04e8561e880e538f95b21c54669f861a63'
AND (
token = 'YJd/wq5ZiKwreCthfvuxGlpoP/o5gausrrZKSR9C/Zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)