UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Nt1rWFbdqb3I2pti/WL9779QJpeQghtT9V4qPVrihUk=' 
WHERE 
  key_id = '3b2945905088ba5e2eb33c4b8a50e1481a72eb9477ba9b8e5393ffca4353a523' 
  AND (
    token = 'Nt1rWFbdqb3I2pti/WL9779QJpeQghtT9V4qPVrihUk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048