UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bHgyA4mvLmpRPni2su85v4pt1RJW+70KcZ3pPQCd0ws='
WHERE
key_id = 'b251d3046695cc65c4462d57e674d6e1101d586929153cbe770d04283616927b'
AND (
token = 'bHgyA4mvLmpRPni2su85v4pt1RJW+70KcZ3pPQCd0ws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)