UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NzKepyh0jflU7IM96J8YqgUAciA4keBX6OvNljCk3vc='
WHERE
key_id = 'f8a733589391e8f080ef11a0a865b3f267f96ef9afd8003bf88a8df327f7bc91'
AND (
token = 'NzKepyh0jflU7IM96J8YqgUAciA4keBX6OvNljCk3vc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)