UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BfHCvVD0IAGrYmaOUGABGslety/evcqUfgNVMeBCcnI='
WHERE
key_id = '942c99602634aa9919dcff35c2f937161b82329b0e29e46f9bf4b3544c8156be'
AND (
token = 'BfHCvVD0IAGrYmaOUGABGslety/evcqUfgNVMeBCcnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)