UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P5wyl+j9UHrdUDcOv+5GAA9lyyDx3rK2yFtG1Jow5Ic='
WHERE
key_id = '3c5e80e5c07b8cb3e4fedd1da131b14943f49b46291f5ea3b37301597aa07a1e'
AND (
token = 'P5wyl+j9UHrdUDcOv+5GAA9lyyDx3rK2yFtG1Jow5Ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)