UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dNpOivGYP9wD0Zf28/PEtMHal8iT1KRfHSEVhm66EBs='
WHERE
key_id = 'dfa0ab759029db2bfa79dd84a0df9e05ffb78874aba97d873abbf729e7b1bed5'
AND (
token = 'dNpOivGYP9wD0Zf28/PEtMHal8iT1KRfHSEVhm66EBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)