UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lYoN6Hn4p6egSCRp9yt7LEs096UG7eCcTNdSrPKngNA='
WHERE
key_id = '9bd2934d119987510595859f4c8a6877a9aac05e19b87ad1cab141c430d692df'
AND (
token = 'lYoN6Hn4p6egSCRp9yt7LEs096UG7eCcTNdSrPKngNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)