UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A7ZC3ab4bFEQchCzIiNe18T+fJKt3p+EdycAnvEaSUI='
WHERE
key_id = '49b27e4078039a16ed62e56868e1d7e319b29785b7362629bb875b55f1a2f364'
AND (
token = 'A7ZC3ab4bFEQchCzIiNe18T+fJKt3p+EdycAnvEaSUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)