UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RyPnbIKd+2CRKlJFjU83/0QDLBfgEDZLWH+iCI+SDNc=' 
WHERE 
  key_id = '9caeedbe2c3a5a2b5248d017f32355eed870fa26f4566c2d493211ea69e0411b' 
  AND (
    token = 'RyPnbIKd+2CRKlJFjU83/0QDLBfgEDZLWH+iCI+SDNc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024