UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zi/7WPwwZY0MrdspLKL1KJjhHrwsUiEXD+XV0kk06zk='
WHERE
key_id = '54126a58e4a7ee26cb415a45d13dc043ecea2dab3925191a8f0822277b30a6f8'
AND (
token = 'zi/7WPwwZY0MrdspLKL1KJjhHrwsUiEXD+XV0kk06zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)