UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xAZV9j/Qtx9QzmrEAtErB7OGx4ahTcciIYY+W/XgEhE='
WHERE
key_id = '64812e24e0403009755e439c2e09edd39e61d101454b65c9a8a2044df10a0f56'
AND (
token = 'xAZV9j/Qtx9QzmrEAtErB7OGx4ahTcciIYY+W/XgEhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)