UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U7NYJzwAhLs3GWsirFEct1Y3GyWOyAaxeCXjQwm3vhg='
WHERE
key_id = '23bf8f90234792b552f8b1198badd26464c1dfd61443288d38683b6eb08f68a9'
AND (
token = 'U7NYJzwAhLs3GWsirFEct1Y3GyWOyAaxeCXjQwm3vhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)