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