UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YyCOyc4JxXY8XG/5SV3PQQc1hFz2w79RCcz/hFuQEA='
WHERE
key_id = 'f9c8f840bf98f3aa5289127b5be3a5ba3ebdbd5a60389fded66e32860df492ca'
AND (
token = '1YyCOyc4JxXY8XG/5SV3PQQc1hFz2w79RCcz/hFuQEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)