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