UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gpx7YowUhz31e13cm551s2vdC862yYq2vAJLBaAfvLI='
WHERE
key_id = '6d8bd97a2336db10e8782d8336c058d91477658d99431f7327b3fd9d81611734'
AND (
token = 'gpx7YowUhz31e13cm551s2vdC862yYq2vAJLBaAfvLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)