UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qPx0FwHcyxMpwyY0Qf3n0Q3jE2SecjckkrpNjW5HpI='
WHERE
key_id = 'e28530a4f3eee6756ec3dea78b2c151f0275f0ce4620fd7bc94cdc74b09fb860'
AND (
token = '8qPx0FwHcyxMpwyY0Qf3n0Q3jE2SecjckkrpNjW5HpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)