UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fXETi8fGq8TxN+oOkr4DUxbDDmnzgKRsym6pZYfCSek='
WHERE
key_id = 'f9405accc46c25eee4315999f91b8f6d7f961c41f9e861c3eb690ec05113c3c7'
AND (
token = 'fXETi8fGq8TxN+oOkr4DUxbDDmnzgKRsym6pZYfCSek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)