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