UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dPvYWn/lnBFwqZhwygu1QEv8Ok32XecpZlGuTxOb3GY='
WHERE
key_id = 'd9cbfc6decf9dc371dacf297edf06d752b9c68c9f614b1fa33ca2ded41ee3295'
AND (
token = 'dPvYWn/lnBFwqZhwygu1QEv8Ok32XecpZlGuTxOb3GY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)