UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9JbZmm5g7pT7dL+h9pVCEXc86wxwFO7qnFGrZJtWqNo='
WHERE
key_id = '04bdb43a7b58da8639b49cf0d9792bea36d4409cb41baa2744daf4c412ed5267'
AND (
token = '9JbZmm5g7pT7dL+h9pVCEXc86wxwFO7qnFGrZJtWqNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)