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