UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fbyhSL7jwF3PhCoUI2/XRnDPh9bhOzSsg+5DAQUuKB8='
WHERE
key_id = 'ff416ace1325478f333f29df19fe81fe041d2d1d15fc014c6567ac2e496862ec'
AND (
token = 'fbyhSL7jwF3PhCoUI2/XRnDPh9bhOzSsg+5DAQUuKB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)