UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fgw7MevcsVUafmSQ5ZvdKiQDiIv2fD93RYzLIE6JMr8='
WHERE
key_id = '0ad42d65b09301c21e94b1d61360b0b916a9c7ce3ca5b031833a585ed786a23b'
AND (
token = 'fgw7MevcsVUafmSQ5ZvdKiQDiIv2fD93RYzLIE6JMr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)