UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnIcUoJgBaczVwYnoINvohhpW7NW9NnQVeXJuflsUdo='
WHERE
key_id = '3243c4b5e4b90d491a9f685658524acf1fe3406525417537e0661e1e2d37dfa8'
AND (
token = 'NnIcUoJgBaczVwYnoINvohhpW7NW9NnQVeXJuflsUdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)