UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cVnXi3t7eqRf9Nqj9bs6TudBhHvgFWH2d/xWyBFivoc='
WHERE
key_id = '57ac47efb299c33abcdf36ecf25a888388fd8dc990e8414951c6f69826f5d100'
AND (
token = 'cVnXi3t7eqRf9Nqj9bs6TudBhHvgFWH2d/xWyBFivoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)