UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X2gFKx94aWhVjf/TR7c5Zy4noLPRtg/RTsNBzhtPVGc='
WHERE
key_id = '3f05a0786769d2371d9199c0394f1b994107ec8d66ff0154ee509a32c505b29c'
AND (
token = 'X2gFKx94aWhVjf/TR7c5Zy4noLPRtg/RTsNBzhtPVGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)