UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'np5vYrirjG49Hu9gjZ2SfiwopYG2ZAtalS5jtYhrR0g='
WHERE
key_id = 'da911e4f81607b5ff995bd49d3acd312ec5ab21d73af8b2024d5ebb81fb1a786'
AND (
token = 'np5vYrirjG49Hu9gjZ2SfiwopYG2ZAtalS5jtYhrR0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)