UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Iu8YoT35KUQzqu12QK10kfm3F5RzGaLxngpIa5HbhD4='
WHERE
key_id = '89c84904a855e81a5c887738e161b034672d864e9d97b628ed822b0eb8cd4e28'
AND (
token = 'Iu8YoT35KUQzqu12QK10kfm3F5RzGaLxngpIa5HbhD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)