UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fFfTtZBbwnJsA5lVEB8XUOMsydsI2GgcoM4c9h4/4IE='
WHERE
key_id = 'bb417c0ef6bc8943778f2022395055774f439897f6cf69f130a21700d5190ee9'
AND (
token = 'fFfTtZBbwnJsA5lVEB8XUOMsydsI2GgcoM4c9h4/4IE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)